<?php

/**
 * php-excel
 * 
 * The MIT License
 * Copyright (c) 2007 Oliver Schwarz
 * Permission is hereby granted, free of charge, to any person
 * obtaining a copy of this software and associated documentation
 * files (the "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use,
 * copy, modify, merge, publish, distribute, sublicense, and/or
 * sell copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following
 * conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
 * HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
 * OTHER DEALINGS IN THE SOFTWARE.
 */

class Excel_XML_Generate
{
	/**
	 * Current object instance (Singleton)
	 * @var object
	 */
	protected static $objInstance;

	/**
	 * Initialize the object
	 */
	public function __construct()
	{
		// include the php-excel class
		require (dirname (__FILE__) . "/class-excel-xml.inc.php");
	}

	/**
	 * Return the current object instance (Singleton)
	 * @return object
	 */
	public static function getInstance()
	{
		if (!is_object(self::$objInstance))
		{
			self::$objInstance = new Excel_XML_Generate();
		}

		return self::$objInstance;
	}
	
	/**
	 * Generate the excel file of the form.
	 * @param string file name.
	 * @param array resource of the excel file.
	 */
	public function generateExcel($strFile="test_drive", $arrExcel)
	{
		// generate excel file
		$xls = new Excel_XML;
		$xls->addArray ( $arrExcel );
		
		$templorily_xml = "";
		$templorily_rs = "";
		// Generate the templorily file.
		// All header, body and footer.
		if (file_exists(TL_ROOT . "/templates_c/$strFile.xml"))
			unlink(TL_ROOT . "/templates_c/$strFile.xml");
		
		$templorily_rs = fopen(TL_ROOT . "/templates_c/$strFile.xml","a+");
		
		$templorily_xml .= stripslashes ($xls->header);
		$templorily_xml .= "\n<Worksheet ss:Name=\"" . $xls->worksheet_title . "\">\n<Table>\n";
		$templorily_xml .= "<Column ss:Index=\"1\" ss:AutoFitWidth=\"0\" ss:Width=\"110\"/>\n";
		$templorily_xml .= implode ("\n", $xls->lines);
		$templorily_xml .= "</Table>\n";
		$templorily_xml .= "</Worksheet>\n</Workbook>";
		
		fwrite($templorily_rs, $templorily_xml);
		fclose($templorily_rs);
		
		// Generate the attachment file.
		$xls->generateXML ($strFile);
	}
}
?>